SELECT col7 , col5, FIRST_VALUE(col5) OVER(PARTITION BY col7 ORDER BY col5) FIRST_VALUE_col5 FROM "allTypsUniq.parquet"
WHERE col5 IN (
    TIMESTAMP_TO_MILLIS(TIME_PARSE('1947-07-02 00:28:02.418', 'yyyy-MM-dd HH:mm:ss.SSS')),
    TIMESTAMP_TO_MILLIS(TIME_PARSE('2011-06-02 00:28:02.218', 'yyyy-MM-dd HH:mm:ss.SSS')),
    TIMESTAMP_TO_MILLIS(TIME_PARSE('1950-08-02 00:28:02.111', 'yyyy-MM-dd HH:mm:ss.SSS')),
    TIMESTAMP_TO_MILLIS(TIME_PARSE('2012-06-02 00:28:02.418', 'yyyy-MM-dd HH:mm:ss.SSS')),
    TIMESTAMP_TO_MILLIS(TIME_PARSE('1985-04-02 00:28:02.638', 'yyyy-MM-dd HH:mm:ss.SSS'))
)